package com.hnqcgczy.shop.dao;

import com.hnqcgczy.shop.vo.TProduct;
import com.hnqcgczy.shop.vo.TUser;

import java.sql.SQLException;
import java.util.List;

public interface IProductDAO {
    //查询所有商品
    List<TProduct> listAll() throws SQLException;
    //分页查询
    List<TProduct> queryAny(TProduct product,int page,int pageSize) throws  SQLException;
    //根据ID查询商品详情
    TProduct  queryById(int tp_id) throws  SQLException;
    //根据ID删除商品
    boolean deleteById(int tp_id) throws  SQLException;
    //根据ID修改商品
    boolean updateByid (int tp_id) throws  SQLException;
    //新增商品
    boolean insert(TProduct tProduct) throws  SQLException;


}
